select * from products where pro_name like '%color%ment%' or pro_des like '%color%ment%'union all select * from products where (pro_name like '%color%' or pro_des like '%color%') or(pro_name like '%ment%' or pro_des like '%ment%') and (pro_name not like '%color%ment%' or pro_des not like '%color%ment%')
Fitted Organza Appliques Quinces Dresses with Two-toned Ruffles
Nice Two-toned Ruffled Quinceanera Gown Dress with Appliques
Multi-colored Sweetheart Ruffles Sweet Fifteen Dress with Beading
Fashionable Fuchsia Sweetheart Dress for Quince with Embroidery
Multi-tiered Strapless Sweet Sixteen Dress with Beading and Ruches
Yellow and White Quinceanera Party Dresses with Beading Hot Sale
2014 Pick-ups Beaded Sweet 16 Dresses in Apple Green and White
Custom Made White Strapless Sweet 15 Dresses with Embroidery
Red and White Pick-ups Sweet 16 Dresses with Hand Made Flowers
Beaded Sweetheart Dresses for a Quince Pick-ups in Teal and White
Elegant Aqua Blue Pick-ups Dresses for 15 Beading with Bowknot
Purple Organza Ruche Dresses Quinceanera with Appliques Decorate
Fashionable White Sweetheart Ruche Dress for 15 with Embroidery
Dark Green Ruche Sweetheart Taffeta Dress for 15 with Embroidery
Apple Green Strapless Appliques Quince Dress with Ruffled Layers
Light Blue Sweetheart Quinces Dresses with Appliques and Ruffles
Lavender Appliques Organza Quince Dress with Hand Made Flower
Multi-color Ruffled Quinceanera Dresses Sweetheart with Beading
Traditional Sweetheart Ruffled Multi-color Sweet 16 Dress online
Tulle Sweetheart Beaded Multi-color Dresses for Quince on Sale
Brand New Appliqued Halter Top Multi-color Sweet 15 Dresses
Discount V-neck Floor-length Beaded Pink Dress for Sweet 15
Customized one Shoulder Pick Ups Olive Green Dress for Quince
Ball Gown Embroidery Pick Ups Dress for Quince in Royal Blue
2014 Spring Brand New Appliqued Strapless Blue Sweet 15/16 Birthday Dress for survivor
Sweetheart Appliqued Ruffled Medium Slate Blue Sweet 15 Dress
Ball Gown Strapless Embroidery Purple Dresses for a Quince
The Best Strapless Rhinestones Ruffled Colorful Quinceanera Dress for Paris Fashion Week
Off The Shoulder Appliqued Tiered Multi-color Quinceanera Dress
2013 New Arrival Flowers Ruffled Multi-color Sweet 15 Dresses